Modify Data files or Log Files
Description
The plugin is designed to modify Data file or Log file in MSSQL server database. Following parameters can be modified:
- Logical Name
- Initial Size
- Auto Growth
Known Issue:
When you select values for Instance name or Port field from a previous step input (that is, Generate Rows or Microsoft Excel Input etc.) the corresponding Port or Instance name is disabled but may be unlocked when revisited
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Server Name | The Hostname/Server Name/IP of the MSSQL Server. This field is mandatory. Drop down is available. |
| 3 | Instance name | The instance name of MSSQL Server instance. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 4 | Port | The port number of the MSSQL Server. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 5 | Username | A username of the MSSQL Server. |
| Password | ||
| 6 | Password | Specify or select the password, as required. If the checkbox Accept Value as variable/static is selected, then the password field appears as a text box and accepts static or variable values. OR If the checkbox Accept Value as variable/static is not selected, then the password field appears as a dropdown in which you can select a field from the previous steps. |
| 7 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password. Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button | ||
| 8 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for previous step fields. Test Connection button only works with static values and environment variables. |
| Input Fields | ||
| 1 | Database Name | Name of the Database on which the datafile/log file is to be created or Select from the list populated by clicking Get Database Button. This field is mandatory. |
| 2 | Button: Get database | Populates the list of database from the connected Instance. |
| 3 | Logical Name | Name of the data file or log file that is to be modified. This field is mandatory. |
| 4 | Button:Get Logical Name | Populates the list of files from the selected database. |
| 5 | New Logical Name | New name to the specified data file or log file. If value entered then Logical file name will be changed to the specified name |
| 8 | Initial Size(in MB) | Size of the file should be mentioned in MB.If a value is provided, then it is considered that you want to modify the Initial Size of the file chosen above. |
NOTE
Get Database, Get File Group and Browse button does not work for previous step variables. All the buttons work only with static values and environment variables.
| No. | Field Name | Description |
|---|---|---|
| Autogrowth Fields: | ||
| 1 | Enable Autogrowth | Acceptable values are “Yes” or “No”. These are visible when you hover over the field. When value is Yes, it is considered that you want to enable Autogrowth for the file.If No is selected any entries made in the fields below is ignored. |
| File Growth | ||
| 2 | Growth In Percent /In MB | Acceptable values are Percent or MB. If Percent is chosen then you specify growth value in percent below. If MB is chosen you are specifying an absolute value for file growth. |
| 3 | Value | Specify the value for growth of a file in percent or MB as chosen above. |
| Maximum File Size: | ||
| 4 | Unrestricted File Growth | Acceptable values are “Yes” or “No”. These are visible when you hover over the field. When value is Yes, you allow the Unlimited growth of the file. If Yes is selected any entries in the field below are ignored. |
| 5 | Restricted File Growth(MB) | If Unrestricted File Growth is No, specify the Restricted size to the file in MB |
| Output Fields | ||
| 1 | Result | Output field to hold the result of the successful plugin execution.For step error handling refer Error Handling This field is mandatory. |